SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368450 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368450 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836604,96640,1016592,853033,703801,343224,557583,749545,121339,177740,817273,148010,656362,15548,618489,152945,281299,411064,169293,413165,446442,72430,930239,135441,225928,217587,410462,1020098,115956,966482,461878,328103,378988,310091,177238,450296,466666,124319,355379,66378,444559,706969,409797,213556,653842,844331,812348,807852,994379,81924,946996,111211,371528,701899,704342,799347,33970,377269,193701,514171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001232s ]