SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134104 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134104 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793166,923,499679,57747,165684,966315,69873,331537,364670,95692,984907,91027,661462,5643,740212,329342,569805,354676,626683,663273,957000,760501,499780,193193,96504,592111,504439,434017,397077,400399,449260,54399,991496,485086,19840,441795,331316,318144,487905,698284,668567,356398,865973,1047464,106506,266645,190107,252252,441969,176441,383473,842081,527869,698245,232915,296536,434891,836582,184548,519637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]