SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503244 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503244 [ RunTime:0.006192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722882,977157,745344,751329,48492,17918,231015,342426,165627,899603,672444,150250,77858,118260,185368,308579,435863,573135,670144,144593,881210,168239,469552,23883,485770,2699,857826,965106,326184,524678,161609,873372,47928,682663,164694,454413,809754,228757,123319,567399,23803,125513,1036764,48665,390000,477752,313082,492078,925951,854747,643774,585234,863273,370689,1043594,1041276,906878,309209,686879,471660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]