SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534197 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534197 [ RunTime:0.003009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339768,263958,541730,200032,505196,982960,184455,742221,718364,701412,525288,349150,678110,515300,135210,149588,168053,211893,139563,756962,761618,890953,655588,467299,763942,1025282,768514,197022,601999,208368,143877,823007,437212,324979,63399,206745,58694,736200,309176,946711,218378,536713,1002079,530184,636717,62468,101197,180809,925568,35669,612947,11436,372402,637714,943962,333056,403373,863830,218976,254497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]