SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537063 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537063 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994738,570863,330578,556756,360982,843487,730544,507338,756011,106300,853817,511934,121198,529524,313718,1010687,904371,259850,505839,920866,928676,164878,371027,609948,550866,1017653,486209,1016229,455911,307541,251559,986191,1012144,588342,332549,253128,726634,14510,1025150,401057,335444,520686,637980,98980,53437,567214,464750,241774,624498,219052,865773,730092,883988,512094,24535,657766,652440,1011908,751296,475573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]