SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414077 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414077 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805451,834182,90755,623999,724497,41980,465918,348244,1019269,167433,861583,951559,83532,101231,792034,103987,779591,542033,442847,878819,507316,800054,639542,347416,916450,421010,573490,336567,415389,452475,207313,204007,66115,68302,899797,29330,528755,546084,826157,723753,670890,829771,491810,209349,170666,685850,988335,202760,996313,900497,540436,952803,1005251,382372,867043,970497,334638,373444,224767,248730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]