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` = 1040447 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040447 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550059,42894,117597,569877,698881,617188,507187,413473,163375,311831,232969,209069,526547,991287,172028,296592,586098,738373,336232,1027176,857121,217397,471453,543719,837577,409698,283851,237329,438573,152741,933728,475717,351218,651199,677184,324170,6152,772070,199177,418653,1017052,202064,944490,600100,25626,268297,597597,182568,490134,592024,183550,673365,594653,786534,418994,771692,580654,641123,255718,232168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]