SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291876 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291876 [ RunTime:0.002768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704471,791506,799887,215105,752967,543146,443703,524342,102170,682959,311379,148804,865141,728017,761950,595189,1045981,971382,251705,342543,359918,999792,913064,953151,195083,181153,500597,439129,1018968,372244,483064,828371,922323,979827,122720,685790,989299,534620,706510,228832,907890,340898,95013,396182,236993,542680,517855,786407,385929,825094,446581,724938,300236,238805,876708,368005,453478,276499,449065,363566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]