SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332520 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332520 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17562,802632,226017,643434,192692,759916,574354,998892,905389,501563,769952,1036012,938744,955062,528028,86875,210511,158272,616904,84555,551939,178627,710196,431745,668489,670431,240708,844369,826385,158379,552013,416633,473276,667294,151943,469585,668173,482988,360120,739404,590066,932135,1026338,947983,217256,203249,616598,738488,301579,105170,826000,939871,1032178,860809,913018,1003133,823980,882436,454881,252266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]