SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396312 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396312 [ RunTime:0.002600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331706,171512,695866,721809,131488,148305,773190,136654,46073,391867,92269,564989,271352,449412,403682,177011,1013770,626875,345651,268423,784814,499458,459789,309382,715531,905513,661752,133055,65590,636369,119611,21641,911456,76393,897396,839649,58154,556998,113671,992056,421245,935465,741040,77675,78573,8067,904224,1013528,255040,224304,147747,575604,324934,101703,649773,957425,1004336,486577,916782,654524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000969s ]