SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531323 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531323 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809828,640596,586428,372854,632311,288210,218692,319031,53289,286143,489459,211388,541703,728208,213448,597448,479929,580119,894187,331710,601046,1048343,696978,587795,549727,214122,810304,736080,711256,352431,959686,414329,245542,525064,572243,109172,311387,677017,943568,565448,1031147,533622,193622,678239,44405,70593,760446,729070,674313,834336,786571,821173,178640,560275,264078,62257,193299,508892,530126,258447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]