SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941753 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941753 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706616,524429,903755,135424,490917,302088,871108,702615,827074,284388,854054,195686,578387,362421,942607,755353,383415,1041846,732528,1039642,508414,152260,907412,831062,1038147,412793,396697,754179,239979,182366,230309,539700,912465,442880,713587,1026073,408704,375651,993651,352209,48342,423389,261986,913914,476504,138267,387597,354842,709025,182111,542640,61574,265933,372189,186682,237035,113880,974075,969021,822463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]