SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195066 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195066 [ RunTime:0.003912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489896,167241,357671,805836,278715,561191,877660,338032,802415,999827,587079,16780,136871,991599,28089,879309,891392,619729,158655,951212,124777,740037,392348,322243,825019,598240,896526,755109,845045,1015654,507936,1025627,906635,24698,12082,953681,168951,372058,865225,810904,812617,895290,586868,711754,819699,307600,898867,994481,525996,653540,722401,747264,564903,973471,420855,524998,733779,796730,765864,284296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195066 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195066 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]