SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006686 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006686 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420330,235025,886894,515007,365554,1029396,378754,345003,1047762,410681,101586,980305,745562,782175,259519,229118,1030454,157603,740585,968977,849731,242817,434972,959187,962120,317832,423422,231356,271726,252806,753397,543021,845449,1048139,218636,81613,274716,334285,485135,108720,160177,514782,200947,608390,544083,669809,617537,917886,267136,264790,264509,453658,200740,584255,156399,83210,231426,530451,902206,568261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]