SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402693 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402693 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405449,205879,864134,893350,286494,1018587,730726,121697,524393,648779,906827,22473,195713,77784,692718,556114,340115,978949,569953,294849,89769,468199,943639,221902,1019997,93141,113658,81411,240719,390484,263620,513668,380380,830415,351418,310172,214765,1029164,500980,222383,537477,59215,87836,407051,490100,323351,509892,499896,585507,993017,162063,357371,853571,398645,472975,401335,666142,694549,828879,144863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]