SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451722 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451722 [ RunTime:0.009196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425603,605320,650894,555225,975086,744370,991819,623898,874478,540932,480025,711265,896593,961037,273538,498932,868843,339341,421185,633860,167864,458557,235585,293689,1028140,286640,519779,560304,945816,198265,651429,525485,348403,263439,218438,101376,733298,547481,1015992,505722,218211,48052,650303,655880,1036674,596339,325015,705429,594029,398653,1019346,235544,602009,725024,708937,864265,595825,702338,666523,717268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001909s ]