SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439244 LIMIT 1 [ RunTime:0.001270s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439244 [ RunTime:0.004658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101044,472519,919757,963821,382785,411334,555358,545488,588171,964656,406899,719117,932303,649620,403522,411283,442574,4530,1003582,510710,100987,312993,889632,968803,1033242,457737,238055,516993,775046,747654,341138,1037402,759914,1669,914042,647006,398084,494056,336014,35901,544833,1021817,885656,631193,765064,319540,28110,120588,191752,801791,880845,358046,337866,186505,640809,60815,206367,817030,292816,514320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]