SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 731031 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 731031 [ RunTime:0.003380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774230,98178,506360,862136,1034127,791891,136167,32025,470849,211804,657780,1002115,46720,36110,548555,828498,568565,819472,66357,249913,263442,709476,906245,834880,205664,783719,385637,961928,490934,864106,891090,380904,906539,68170,101168,479255,880671,746184,565247,304817,401172,141036,951298,921148,937907,417812,135080,557818,764613,992192,1029417,671830,1016913,125477,952627,237417,934553,26314,576729,741440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 731031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 731031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]