SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244908 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244908 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118210,541428,332806,357667,980579,110521,436939,329897,503859,164885,773000,730888,437588,200589,325248,884759,299545,550608,89397,196216,131936,780664,283932,593999,84934,953689,649396,274102,247838,554196,46534,455287,658240,378660,845685,737416,835843,391917,290589,889520,237654,414395,1028994,543986,426563,923463,822249,682987,265253,941050,916972,959890,588310,338765,387559,98740,9710,972027,751286,485482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]