SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460941 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460941 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818097,236654,880795,875739,746366,493028,327166,888064,34663,133865,2687,402984,468109,927214,831610,88324,726921,746015,433127,124175,935307,558985,891444,649142,98875,972003,701716,998607,1044687,7746,375590,429082,282651,1019948,12102,447291,884571,523301,896545,411751,890608,540002,550849,40383,306975,848674,251659,874774,804506,972899,1000851,810222,100795,75183,630544,708233,1017894,1013444,251119,882847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]