SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445621 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445621 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199813,501745,121202,983690,158060,565702,371688,470126,826876,521392,536484,117464,766960,750625,932724,229603,624642,588905,879163,911594,831763,167441,668385,439379,798765,327255,76660,975696,297402,123356,984342,673191,594311,546037,18334,563421,28934,309640,979608,896537,143869,833153,184941,1027549,530270,869089,377883,628530,211850,746728,760818,180405,449573,208589,54468,32431,610187,476413,606182,502959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]