SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32568 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32568 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401302,25250,785008,120394,903532,831206,278788,784951,511526,713963,441013,886662,350821,790092,847580,230078,771088,957556,835537,351246,366180,658826,880332,842971,839441,370205,981226,1008648,71505,907432,103288,961031,907232,119012,123968,656973,1023403,240731,341730,614849,447362,666008,946935,374231,425226,995591,900866,469976,208118,511964,681105,55104,384347,233588,657590,35133,845949,200683,609486,753823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]