SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599875 LIMIT 1 [ RunTime:0.003200s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599875 [ RunTime:0.004520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041814,1045033,673017,300744,349202,224584,565172,451969,984102,449858,761192,508083,294946,301518,765867,367794,391251,947685,957586,675042,374184,959711,305623,374111,801456,502376,899862,630180,761904,791796,352087,955761,310213,135680,844837,119141,569832,593926,703045,675755,373487,144654,114814,713561,13155,706500,867680,710644,552539,948838,183344,567441,952197,517228,333892,563837,447239,933806,876084,472394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003475s ]