SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403538 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403538 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537796,746009,565533,352101,834655,537657,903383,187074,238583,591189,369133,634577,697399,156550,236142,335040,360401,607592,848747,323870,886427,787394,231691,965622,201745,864914,167459,285311,134824,636649,654002,859365,595559,656685,1001881,1001017,366272,761985,705143,565232,845007,501991,852520,1012525,678352,627117,772046,178720,447586,696577,8357,318898,664630,817509,1026388,369969,262767,488432,909031,176051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]