SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498509 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498509 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746397,602465,503127,454048,644803,32725,433725,610597,200099,918711,858433,787842,792750,848998,902361,406800,324201,320263,25104,97129,808077,725172,826598,195225,797198,470627,190378,224014,929210,120852,137676,278758,201817,765502,613428,840406,50700,470498,999788,15944,568752,220736,25261,705269,894006,603193,1011448,716068,300847,276344,107658,273854,23187,1015318,297406,638711,779868,1039750,266250,976880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]