SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523269 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523269 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017216,406382,746235,306620,131516,567780,460194,455093,121337,878323,306210,195707,54309,274002,10220,1020498,551832,646593,38363,28248,88884,169711,384765,204839,333601,385643,513509,538319,409636,274273,366817,198640,1004240,325510,655963,560721,525487,283600,422571,779334,782918,979681,101114,289516,279049,634589,365228,229354,246018,954049,481622,890802,658685,847985,271416,861748,23117,853549,280971,563820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001388s ]