SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002823s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020686 LIMIT 1 [ RunTime:0.012518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020686 [ RunTime:0.002645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761048,742232,592821,807461,1035305,734962,755794,851129,619647,531448,101197,1025236,131492,436069,738753,70185,642007,396132,816599,711932,123465,195171,78743,865856,991820,146430,1037788,379390,477486,650,203297,852663,1000615,878497,721216,279091,785246,884493,164541,646521,306115,215495,360672,64956,315782,3043,614945,488727,939502,958729,818107,1007004,94635,1024483,548765,494888,605539,322926,501544,334803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007304s ]