SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983771 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983771 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235670,42921,792890,925564,346346,776881,66635,783197,635731,882908,626647,425325,95346,721950,980017,85716,830355,1970,898541,204727,806594,159149,168036,835848,979204,865233,953215,748985,1011061,731461,923429,51002,879680,561852,200167,201168,272487,366366,994075,488756,203126,868769,363496,663642,30950,55404,238446,439355,84482,197990,62491,37637,511625,179462,591090,70358,848890,54414,802051,404122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001174s ]