SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408038 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408038 [ RunTime:0.003192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383298,647116,638090,1037536,91093,103007,487504,220230,32428,744948,293161,170659,24405,798626,574915,266354,584207,196764,659150,211629,444283,659810,1002782,1002973,46431,481172,134139,854680,44736,569482,345520,1025014,171262,627585,96548,356726,107539,704594,962303,232496,924179,673606,136740,442064,748435,568571,245854,780140,501171,684384,145962,231319,996471,824458,357905,204721,129694,683820,165489,565705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]