SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429395 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429395 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313395,899058,714864,765890,473309,282184,420121,36454,634060,492605,283883,157747,783105,602536,45681,971584,253445,872323,663494,419426,84142,1016289,503442,876993,279211,325172,335846,456426,271245,367443,789841,268355,937175,573936,1030755,151762,633520,74898,934941,976554,681296,222325,914934,519725,706219,480765,816503,882214,305460,29632,338642,421219,1026884,410333,71863,566057,454329,347829,794422,156164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001569s ]