SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105631 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105631 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917761,196668,654845,448833,848801,294632,810969,1001558,1031235,21901,1038279,523744,1011258,758161,390220,546767,940661,367081,606100,178361,973220,510303,248204,763073,456311,692775,121478,863240,733679,48913,881209,282327,919969,292482,4616,825415,721843,247067,861040,933250,925296,197070,252030,86910,961994,525942,548479,783023,257994,499337,616604,301213,863894,803330,42528,347379,130640,743683,1004386,346890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]