SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505668 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505668 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261674,1039276,587097,718332,951411,17454,387332,934547,705618,175337,14405,476971,456504,108179,376043,582833,219605,797925,942590,255294,292869,411501,378102,766949,887086,808382,282693,1045106,58009,856554,221672,617087,884011,313716,699522,617568,556941,362791,674856,240063,120017,82617,326978,1029342,603595,803897,161625,905153,723254,752136,958446,526484,179369,2352,478100,215293,1041449,686136,833688,504083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]