SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563508 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563508 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731199,476554,171818,1006938,627502,761627,758013,255546,611140,97252,243368,367061,428137,1010411,214481,45347,716433,711532,838199,1006787,1004316,381575,423647,610139,599054,988600,860184,1030782,356189,985978,737546,326129,276947,468042,326800,888852,1026409,146211,684344,118792,683098,946421,761788,1039126,125489,318631,176815,188584,491629,955648,787794,625087,112065,782482,60651,162557,464269,934546,822732,709773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]