SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416283 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416283 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415312,158097,689832,699953,766581,260847,939704,917624,150285,19565,102111,753872,320028,316290,617624,572466,339360,340508,635660,1005747,698637,689851,756810,102871,650796,57277,324672,933717,114878,614599,395660,915142,171222,699565,269089,445721,468553,786534,41693,559105,715499,280498,982186,285707,826696,232097,694569,226370,588736,1018825,504072,337187,146722,710865,1039238,885507,306285,301865,695174,886513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]