SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109830 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109830 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166949,1039156,168751,118061,562316,322840,436570,384075,229077,5845,353913,978366,431790,747411,344095,495972,673164,91084,845825,651899,785124,704549,119876,97864,100481,61512,328632,147234,351833,558424,403496,200960,867009,265819,424763,946132,913415,364087,502208,91980,98074,296704,493129,14469,221128,66366,300475,258776,976651,732307,206374,391123,140156,974949,175718,70624,123680,119372,626022,887778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]