SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027013 LIMIT 1 [ RunTime:0.001199s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027013 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913515,547878,227372,692843,14264,189297,581620,1045851,732763,318422,41641,196321,526170,211574,9922,541740,57788,483741,536573,38726,814907,91384,809454,716814,783920,220746,255734,337036,522022,932625,425670,55376,771862,143891,741410,19445,177327,891216,255908,642269,534311,804257,306440,43736,534071,797260,517387,247918,1003906,693815,489731,407522,89087,689866,693043,591845,331146,347264,79137,869587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]