SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435845 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435845 [ RunTime:0.002755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648504,144574,238835,27426,352975,291220,35080,461101,936267,611427,992822,503858,1003690,804099,830289,591730,837991,392352,730210,315852,1022397,502816,703893,216545,218365,6721,801650,38458,603651,218393,161276,700930,372881,368807,1005316,277864,938096,116724,1008613,843640,940109,595576,952125,830525,994142,482903,311696,821900,654702,914117,519383,234290,887439,1025413,902843,308095,138256,899825,434172,941923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]