SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410984 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410984 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164224,768694,671693,485299,992211,846274,617171,795636,453359,998920,749012,131719,199323,890605,1022050,914170,847804,268522,417141,198706,258227,588000,891889,964418,492555,1023308,645189,1034636,573844,101601,855267,373589,969307,621381,500713,874972,405154,617037,916723,579826,122713,336761,796077,933541,394834,72007,390484,39705,391271,983791,978913,160426,373814,718190,369881,245282,766538,263354,654688,438989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]