SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410083 LIMIT 1 [ RunTime:0.001331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410083 [ RunTime:0.004483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640385,835380,442532,150028,1034035,463111,753564,737484,132622,308772,157874,486305,798576,916290,308995,976600,348930,551605,832903,414485,124041,992883,684610,232769,56720,145287,861031,638176,976262,197710,19709,901065,711967,753015,554325,515468,448498,647457,193599,1040825,106939,31254,924505,691370,807005,877863,828977,866361,557250,972789,325364,749540,395868,612913,880830,601076,33599,3432,281272,63918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]