SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451708 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451708 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818369,400881,318519,438422,627018,884073,183852,624766,944286,555943,601211,408610,1012077,424177,196394,216527,606709,370353,186091,328559,959379,249417,277797,1014742,920438,390866,937998,768821,120086,560024,25454,186123,937573,43203,203386,505956,946913,935999,499866,183384,761380,122342,1039414,334726,778740,408919,253929,195330,930580,456211,486778,1011373,755419,1044433,545539,749505,640625,948785,858542,154816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]