SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017161 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017161 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321283,434133,580025,638667,67944,595006,118077,609276,909354,353149,32645,849251,704090,644219,857114,377238,189622,86488,434383,531369,558258,771234,852798,30493,370538,988127,244837,886633,544063,822069,483371,185958,715646,406477,4856,833667,930699,995398,886617,119120,796112,1046315,963857,1014276,388938,344031,467277,531155,1031511,164377,196448,31946,432029,842310,533946,577197,736406,925288,721654,13793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]