SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282014 LIMIT 1 [ RunTime:0.001265s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282014 [ RunTime:0.002370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480210,609466,878714,750257,700100,280082,454141,269757,116740,543042,966696,852048,208853,550931,575278,40150,18875,542973,362077,133934,1007139,853513,770316,99379,12665,43140,763541,114696,137734,847256,744459,888943,311878,246091,944995,132878,211991,189813,499543,472250,586992,40263,201658,383824,793178,307335,794294,380346,510305,1043092,180871,113938,106155,1038141,872377,113556,502691,895903,185392,354823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]