SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528201 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528201 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715251,581627,797736,1008139,1004227,808531,640721,488002,725667,320483,859706,504181,57914,721656,45884,630588,148865,240540,240097,811061,478931,8771,414824,470215,916263,439626,300520,346474,815185,262010,876141,218148,2436,689147,460829,359216,715452,589782,955028,430419,958213,113508,283990,999247,502111,672364,927367,605958,572237,605287,967661,335105,593234,539771,158154,907472,834613,476547,675845,892981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]