SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523312 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523312 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185580,463689,69574,679602,454600,320433,680456,446002,219716,695002,351884,1022803,987168,718172,798120,238899,919477,431269,650835,559889,831613,656720,420746,761394,1007773,259032,737758,822001,54611,879082,579529,314349,318763,957302,253373,272419,611307,871244,614987,307919,613215,457672,215435,10006,196869,674546,815098,398059,719923,330306,640800,670752,58043,128840,539851,636477,702123,267959,670533,491371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]