SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105281 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105281 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008830,383931,936052,731944,814160,219535,567143,212176,775624,916916,610166,781348,623445,28984,36207,84786,120606,57774,86502,594038,119141,39432,244100,146974,266425,711632,451177,986239,678380,42842,301184,531476,591709,763938,759505,492056,594845,138482,126661,392693,403784,677456,48393,571875,905263,738128,602243,332412,875501,228972,19177,821723,750865,793264,327016,1042870,883771,801807,1003518,194536) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]