SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295364 LIMIT 1 [ RunTime:0.004444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295364 [ RunTime:0.007591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754623,872428,764011,556490,1034717,482314,50293,845699,586212,637297,240976,280668,457162,1009720,188614,89876,343477,354365,364759,95165,1046323,366500,675322,234309,790357,893271,95089,927538,589727,818345,1030981,667466,926404,543788,274843,153673,277704,502833,174827,433162,404575,399135,259992,1039043,223951,484263,766769,468016,671742,1030007,601196,70857,445082,37660,350885,138214,1017010,871698,46153,969611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002045s ]