SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419865 LIMIT 1 [ RunTime:0.001978s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419865 [ RunTime:0.002551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491312,201717,201748,335618,134149,100755,206688,957005,939980,404517,1033901,743418,548219,378719,966989,777496,591038,688337,807552,192909,150708,370407,250621,846938,138092,205351,566582,34796,1033048,239008,834052,675124,274343,12764,619185,658862,682930,407325,244347,154896,97978,315876,958069,278461,372903,417291,279836,994027,461808,603513,919515,971915,32705,762441,117317,991878,558279,693490,708233,735755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001184s ]