SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504547 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504547 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272081,454994,539402,614845,615128,1030355,151920,226486,76207,502475,201450,39692,410721,813409,419212,803962,706992,784343,180568,145901,914170,435627,599412,136034,828808,498469,203443,334684,648480,161868,326546,343844,406117,1020102,414034,53029,213582,184816,101211,92061,274824,18988,713253,975787,558412,432969,977884,245338,1039124,316014,839885,995288,716825,1048364,574062,669139,516736,488712,8364,285556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]