SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5436 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5436 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119036,515685,847776,912418,229623,876468,409004,483164,1031219,821696,60076,251806,34088,823432,476203,880245,1025193,313084,316301,523782,69362,212393,576126,679356,752827,223147,320853,904951,631460,349966,210005,438333,597717,354288,251100,770278,377776,485746,1001385,81070,667199,640703,695609,148725,274792,122410,506129,262139,342852,845345,389875,509874,487403,728249,470035,148484,665011,731611,293469,570005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001382s ]