SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005435s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631491 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631491 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412378,978445,510878,128941,504568,161599,844775,516903,279718,539492,421403,156563,372419,49510,781442,498958,936878,863136,588833,713951,1042844,648349,644087,1017164,375973,838946,3313,1025736,499045,179342,146929,244131,195104,354096,85512,681624,964985,416512,632531,561382,280032,177191,308344,680220,305671,29637,612833,731693,154817,605197,373702,120168,403048,299285,239581,307943,497759,743262,778875,171734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001068s ]