SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403348 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403348 [ RunTime:0.003260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133142,258865,724554,890146,982290,491116,393018,483632,262512,199441,523016,566595,868777,343899,128049,781337,776861,215047,121984,698532,299885,1004584,643838,383480,641379,225093,232083,89358,231379,70450,48056,1001873,31758,23597,749896,982806,54188,490208,527083,845062,373988,645159,1005273,447741,130478,121926,354645,709214,1015369,1003654,990444,505258,368998,859966,55049,343871,274996,642762,413455,876955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001325s ]