SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509302 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509302 [ RunTime:0.003912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407326,1036980,228001,468108,732591,355391,839930,393090,7506,112689,1038812,199217,424454,685948,976645,984574,305085,723428,908525,196414,328625,136362,819991,964115,164738,223282,486484,503070,118565,95635,195145,15773,695070,88631,433620,8415,913425,985520,93711,276697,60219,813752,907042,768045,103091,11625,524712,476391,27951,169883,50133,599602,125036,84396,454995,305746,286137,505351,422188,393979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001418s ]