SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410616 LIMIT 1 [ RunTime:0.002388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410616 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938759,993564,399274,302654,711686,947026,873770,54393,1025725,791537,100265,836127,118532,750519,646038,112160,399231,196639,471820,182802,505003,526096,723391,76324,128035,449464,35421,845176,620298,1024042,504185,174859,187908,1034918,942299,943302,493891,942753,567919,387119,19742,464819,271183,758555,624450,654428,70512,657021,97362,581697,442460,594135,43996,399395,160444,215326,892580,497327,756263,942488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]