SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041500 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041500 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144264,666401,982817,407929,302004,144605,638481,206320,885633,638067,786351,424520,921858,150687,286693,175371,627689,600647,715998,854409,908602,618508,363672,744937,129656,558534,956889,407606,1020804,330012,121533,78733,607599,246882,137879,527331,990493,973369,995549,585846,702970,663153,662666,950586,193615,662442,839351,96684,604417,400684,623286,1032355,920732,871190,288141,912753,928981,769018,220607,641286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]