SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3933 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3933 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610244,347697,122287,229705,498382,546686,1034143,84359,40568,541202,436778,372802,148537,880649,375806,40111,30031,386075,765919,437257,9262,624420,349672,144817,522391,358561,400460,202204,214345,310747,1000689,800002,868245,360396,844654,852137,347528,244614,395470,175498,149773,46484,928101,498305,113256,122974,979757,541439,611791,910279,699179,280120,553312,388470,308252,505409,286557,787506,266882,1007477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]