SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68135 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68135 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992161,611318,157831,889588,518847,1017016,387872,328260,905381,540833,534865,397340,119207,134501,202776,401816,842598,533352,997791,241219,403814,148760,170926,328611,627065,144935,182555,240728,890202,855848,260409,850146,352772,885685,515914,1010922,763818,135353,865719,122941,45617,382152,349623,754488,203746,287689,338225,619517,711240,104988,976244,542219,540174,160398,299554,976558,902439,9259,5163,1017246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]