SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442027 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442027 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377287,272668,34488,450242,374486,225372,634953,1047881,74187,23232,453298,704602,504336,873660,9615,475877,752415,132764,753482,1041918,830249,396803,40829,165075,281203,515208,757392,915814,796070,126514,1011041,817105,299906,727186,724699,572825,66564,219046,872365,595184,135184,608336,344577,459326,518269,437770,192435,312328,37095,144267,3801,312146,529218,841712,38635,992723,387656,627025,2148,398523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]