SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040052 LIMIT 1 [ RunTime:0.000821s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040052 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871513,684750,246451,591408,128247,211510,601130,252650,740737,498744,736322,753637,657732,135863,984209,942732,669151,809993,675923,982000,353078,1035356,1000674,871452,266245,504911,883591,148040,796613,85282,855955,694005,125442,87510,183526,142689,964749,685986,815925,459298,344111,123170,601237,1036146,478466,8360,474214,106837,433298,16959,267064,652355,240066,311692,729167,1009563,633944,154844,664280,232674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]