SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524806 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524806 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397479,732292,118887,1027249,242076,289310,505164,993021,61354,317094,32062,883082,461518,721271,342975,552537,667388,727977,151555,706470,448293,919345,600494,307704,132394,778971,330329,941847,428275,672520,890437,716060,939562,524715,370981,354436,225230,272817,1039407,883758,416165,840317,453631,752479,104487,117825,93531,28264,55306,205341,950812,10759,675858,307377,865114,866017,561268,530391,91401,466869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]