SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520688 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520688 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69033,157883,158141,822338,91885,601918,963528,177686,510053,90509,150332,430372,257635,1035119,648797,281298,1475,267653,464046,124287,365001,623307,182116,483771,330872,316179,1012118,22703,1033393,988139,203060,578261,714232,969648,599939,90349,696366,501241,747531,979021,25755,802598,908836,650019,12125,742608,138434,157381,91662,570983,160812,780693,508047,382296,112345,502443,638302,6911,884498,527298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]